Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 26597 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 |
Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..
What are the different ways to implement parallel processing in informatica?
How do you load alternate records into different tables through mapping flow?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
How to load data in informatica ?
In a simple mapping when i use aggregate t/r with out any condition or group by, i am getting output as only last record in the table . can any one explain it please.........?
Design a mapping to get year of join for each employee.
wat transf shud i use to achieve this id sal id sal sum src-1 20 tgt 1 20 40 1 20 1 20 40 2 15 2 15 35 2 20 2 20 35
What is the difference between OLTP and ODS?
HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND LOOKUP?
I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution
how many ways can we implement SCD2?
Teradata 
