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
- 15 Answers
- 22181 Views
- TCS, I also Faced
- E-Mail Answers
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 |
tell me the datawarehouse defination,and it is maintaing hystorical data meaning,what is the use
what is the difference between onsite & client site?
What are Target Options on the Servers?
Can I create one wrkflw which will run different wrkflws on schedule time?
If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?
What are the basic needs to join two sources in a source qualifier?
What is the need of an ETL tool?
How can we get two output ports in un-connect transformation?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
0 Answers Cap Gemini, Cognizant,
I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.
What is junk dimention?
how we do performence tuning in informatica
Teradata 
