how do u get the first record from 50,000 records ?
Answer Posted / bsgsr
simple. connect the source to ranker select top and set no
of ranks to 1.
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
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?
What is fact table? Explain the different kinds of facts.
How would you join a node to the already existing domain?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What is a joiner transformation?
Explain lookup transformation source types in informatica
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
State the limitations where we cannot use joiner in the mapping pipeline?
What is the need for an etl tool?
Explain target update override in informatica
What is a mapplet/worklet in informatica?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
In informatics server which files are created during the session rums?
What are the tasks that source qualifier perform?
what is song in infrmatica...?