Q&A Categories

Data-Warehouse

Will the data stage consider the second constraint in the transformer once the first condition is satisfied

Will the data stage consider the second constraint in the transformer once the first condition is satisfied ( if the link odering is given) '

Answers No Answers In: DataStage By: yogesh [ Grey Star Level] Sep 7, 2010

Why we use lookup transformations?

Why we use lookup transformations? Lookup Transformations can access data from relational tables that are not sources in mapping. With Lookup transformation, we can accomplish the following tasks:Get...

Answers No Answers In: Informatica By: rakesh [ Grey Star Level] Sep 7, 2010

Why we use partitioning the session in informatica?

Why we use partitioning the session in informatica? Partitioning achieves the session performance by reducing the time period of reading the source and loading the data into target. '

Answers No Answers In: Informatica By: ramesh [ Grey Star Level] Sep 7, 2010

Why we use stored procedure transformation?

Why we use stored procedure transformation? For populating and maintaining data bases. '

Answers No Answers In: Informatica By: samir [ Grey Star Level] Sep 7, 2010

Why we can't create an aggregate on an ODS Object?

Why we can't create an aggregate on an ODS Object? '

Answers No Answers In: Business-Intelligence By: Anu [ Grey Star Level] Sep 7, 2010

Why the sequential file not used in Hash Lookup?

Why the sequential file not used in Hash Lookup? '

Answers No Answers In: DataStage By: vikas [ Grey Star Level] Sep 7, 2010

Why u use repository connectivity?

Why u use repository connectivity? When u edit,schedule the sesion each time,informatica server directly communicates the repository to check whether or not the session and users r valid.All the metadata...

Answers No Answers In: Informatica By: rakesh [ Grey Star Level] Sep 7, 2010

Why use the lookup transformation ?

Why use the lookup transformation ? To perform the following tasks. Get a related value. For example, if your source table includes employee ID, but you want to include the employee name in your target...

Answers No Answers In: Informatica By: ravi [ Grey Star Level] Sep 7, 2010

Why sorter transformation is an active transformation?

Why sorter transformation is an active transformation? '

Answers No Answers In: Informatica By: yogesh [ Grey Star Level] Sep 7, 2010

Why might the optimizer use a table scan when an index is available?

Why might the optimizer use a table scan when an index is available? '

Answers No Answers In: Abinitio By: ramesh [ Grey Star Level] Sep 6, 2010

Didn't find what you were looking for?

Add your Question to the site.

You must be Logged In to Add a Question.

Not a member yet? Sign Up Now »

Star Points Scale

Earn points for Asking and Answering Questions!

Grey Sta Levelr [1 - 25 Grey Star Level]
Green Star Level [26 - 50 Green Star Level]
Blue Star Level [51 - 500 Blue Star Level]
Orange Star Level [501 - 5000 Orange Star Level]
Red Star Level [5001 - 25000 Red Star Level]
Black Star Level [25001+ Black Star Level]