If a table contains 100 records we have to fetch 50-100
records from source to target?how
Answer Posted / tauseef
hai Tauseef,
as per my knowledge we can Fetch 50-100 records
by using rownum>=50 in source qualifier it self after generation sql query
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
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 ?
How do you change a non-reusable transformation to reusable transformation?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
How do you convert single row from source into three rows into target?
What is parallel processing in informatica?
What is confirmed fact in dataware housing?
define galaxy repository in informatica
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What is meant by pre and post session shell command?
what is the difference between informatica6.1 and infomatica7.1
Did u used latest transformations of 8.6.0? for what?
what is the -ve test case in your project.
What is union transformation?
what is mean by complex business rule ?