Suppose i have 10000 records.First time i have to load 1 to
1000 records and second run i have load 1000 to 2000
records and third load i have to load 2000 to 3000 rows .How
will achieve
Answers were Sorted based on User's Feedback
Answer / abhishek kumar
This qn will be solved by setcountvariable() function
variable
$$count -count .
but how.........
| Is This Answer Correct ? | 0 Yes | 3 No |
Answer / raj
BY USING INCREMENTAL LOADING CONCEPT,WE CAN LOAD THE DATA
| Is This Answer Correct ? | 0 Yes | 3 No |
Answer / natrajdreams
Hi experts please explain the following scenario.
Suppose i have 10000 records.First time i have to load 1 to
1000 records and second run i have load 1000 to 2000
records and third load i have to load 2000 to 3000 rows .How
will achieve.
thank you
| Is This Answer Correct ? | 1 Yes | 5 No |
Answer / narendar
Sir i think using Incremental Aggregation Cache
| Is This Answer Correct ? | 4 Yes | 8 No |
If you want to load these records on different files at
different time, you can use Filter transformation else u can
use Router transformation..
In Router trans create two ports and one default port.. and
write conditions according to your requirement....
| Is This Answer Correct ? | 0 Yes | 6 No |
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
tell me the informatica architecture
What is update strategy transform?
What are the types of lookup transformation?
What are the advantages of using informatica as an etl tool over teradata?
we r using aggregator with out using groupby?
7 Answers HSBC, Principal Finance,
what is lookup ?
wt is inline view? when and why we Use ?mail to rayallarv@gmail.com
Source Qualifier is an active t/r but there is no change of row count then y should we called it active t/r & Router , sorter some times no change in row count then Y we called its active t/r?
What is meta data and system catalog?
Mention few advantages of router transformation over filter transformation.