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 |
explain about lookup t/r?
in mapping i have one source and five targets in that data will be loaded into four targets properily in one target the data is not loaded how will u rectify
How we can create indexes after completing the load process?
what is fact table?
What is Test load plan? Let us assume 10 records in source, how many rows will be loaded into target?
What are the join types in joiner transformation?
if we r using aggregator we enabled sorted input but the records r not sorted what happen?
What is informatica?
who to split dimentions into sub dimention
Define mapping and session?
What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.
What is a connected transformation?