Answer Posted / sangee
union,union all,minus,intersect
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Explain the difference between mapping parameter and mapping variable?
what are 3 tech challenges/ common issues you face?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
How to create the source and target database connections in server manager?
What is Data Caches size?
Mention few advantages of router transformation over filter transformation.
Explain what is informatica metadata and where is it stored?
How to create Target definition for flat files?
Slowly changing dimensions, types and where will you use them
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How can we handle two sessions in informatica?
Explain the features of connected and unconnected lookup.
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is sequence generator transformation in informatica?