How to load only the first and last record of a flat file into
the target?
Answer Posted / spandita
After SQ expre/aggregate without selecting group by option
then it displays default last record for displaying first
record there is first function enable this then it displays
1st record.....
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Explain the etl program with few examples.
what is the size of your data warehousing?
Explain what is informatica metadata and where is it stored?
Explain the difference between mapping parameter and mapping variable?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Write the unconnected lookup syntax and how to return more than one column.
What is standalone command task?
Different sorts of metadata that stores in the storage facility?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Explain the shared cache and re-cache?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Explain the different dimensions.
What are the different transaction levels available in transaction control transformation?
How do you load unique records into one target table and duplicate records into a different target table?
How can we handle two sessions in informatica?