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 |
Implementation methodology
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What is a filter transformation and why it is an active one?
i have ten flat files with same structure,if i want to load it to single target,and mapping needs to should show only one source.what will be the steps to taken to achieve it?/
What is the difference between view and materialised view?
Describe an informatica powercenter?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What is parameter file?
Where do we use mapping variables in informatica?
What is informatica powercenter repository?
My i/p is like below 1,2,3,4,5,6,7,8,9,10....100 I want that to be populated in two o/p as below o/p-1: 10,20,30,40,50,60,70,90... o/p-2: 11,21,31,41,51,61,71,81,91.... How to do it in ingotmatica...
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?