Interested to Buy Any Domain ? << Click Here >> for more details...
in informatica,if i have some no.of records,if i want 1st
and 10th records..what will be the method to use?
- 11 Answers
- 33932 Views
- L&T, I also Faced
- E-Mail Answers
Answer Posted / chandrasekhar
You need to use MOD function based on you can filter it
out.. then you will get 1..10..20..30....like we will get it
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
How can you increase the performance in joiner transformation?
What is aggregate cache in aggregator transformation?
what is Active lock explain
How do you convert single row from source into three rows into target?
How do you remove duplicate records in informatica? And how many ways are there to do it?
What do you understand by SOA of Informatica?
Explain scd type 3 through mapping.
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What is a stored procedure transformation?
Explain transaction control transformation in informatica
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What are the types of lookup transformation?
Differentiate between source qualifier and filter transformation?
