Interested to Buy Any Domain ? << Click Here >> for more details...
i have one source 52 million records i want target only 7
records ?how wil you do what logic to implement?
- 7 Answers
- 14078 Views
- L&T, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vijay
Are you saying you want the first 7 records from the source
table?
If that is the case, write an override in source qualifier
and fetch by the row number. That would be the fastest
way.Load into target.
| Is This Answer Correct ? | 9 Yes | 1 No |
Answer / prakash kumar kumhar
can u tell me which 7 records u want?
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / amedela chandra sekhar
IF U WANT LOAD 7 RECORDS FROM SOURCE TO TARGET,
WE CAN USE SEQUENCE GENERATOR T/R
CURRENT VALUE =0
END VALUE =7
RESET ENABLE
THEN DRAG THE NEXTVAL PORT TO EXP T/R
CREATE ONE OUTPUT PORT GIVE THE CONDTION LIKE NEXTVAL =7.
PLZ LET ME IF ANY WRONG
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / jacob
take one sequence generator and poppulate the sequence nos
to all rows then give condition as sequence no<=7.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / sameer
If our source as a relational table then we write sql queries in sour economy qualifier transformation select * from table-name where rownum <=7
But if our soure as flat file
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sameer
If ur source as a flat filemail then we uses first expression transformation and we write expression v1=v1+1 and one output port o1=v1 then after filter transformation and in there filter conditions just write o1 <=7 But if ur source as a relational source then we write select * from table-name
Where rownum <=7
| Is This Answer Correct ? | 1 Yes | 0 No |
What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?
What exactly mentioned in High level design document.can somebody explain me sequentialy.
two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?
HOW TO GET THE LATEST DATA IN SCD ?
How can we improve session performance in aggregator transformation?
Hi, What is exactly node ? what is exactly domain ? How loadbalancer will work ? what is Integration service (IS) ? Can anyone give me exact scenario when I click on start workflow in the workflow manager ? (Note : I am not expecting answer like, node means logical representation of a machine and domain will contain multiple nodes .I gone through Informatica help but I couldn’t understand. I am expecting exactly what is happening in background detailed explanation or Pictorial representation will be highly appreciation ) Advance thanks
What is a design?
How can we use mapping variables in informatica? Where do we use them?
How You Pull the records on daily basis into your ETL Server.
What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?
How can u insert o ne row in the target if that row does not exists in the target and update if it exists
What is difference between Informatica 6.2 Workflow and Informatica Workflow 7.1
Teradata 
