When will you use SQL override in a lookup transformation?
Answer / vanita
For filtering the data in lookup table using where clause, or joing multiple tables to select data or to change the default order by clause with your own order by clause
Is This Answer Correct ? | 10 Yes | 0 No |
What is informatica worklet?
Explain how many types of dimensions are available in informatica?
Tell me how many tables used in Ur project and how many fact tables and dimension tables used in ur project
When you connect to repository for the first time it asks you for user name & password of repository and database both. But subsequent times it asks only repository password. Why?
What are the connected or unconnected transforamations?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
How can we join the tables if they don't have primary and foreign key relationship and no matching port?
Quickly characterize reusable change?
You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 - writer buffer block can hold multiple 7,500 rows - you are loading 40,000 records into the target After how many records will the Informatica Server issue commit commands? a)7500, 15000, 22500, 30000, 40000 b)15000, 22500, 30000, 37500, 40000 c)15000, 22500, 30000, 40000 d)15000, 30000, 40000
What are the different types of repositories created using informatica?
Can we call a stored procedure from a unix script which is run using command task
What is the scenario which compels informatica server to reject files?