hw cn v elimate dublicate values from lookup without
overriding sql?
Answer Posted / surender
yes correct
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What are the designer tools for creating transformations?
Explain joiner transformation in informatica
Slowly changing dimensions, types and where will you use them
draw informatica architecture 8.6 ?
What is confirmed fact in dataware housing?
Explain Dataware house architecture .how data flow from intial to end?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
whats the logic to load the lower level of granularity of data to fact table.
How do you load only null records into target? Explain through mapping flow.
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Explain lookup transformation in informatica
What is aggregator transformation in informatica?