i have one source 52 million records i want target only 7
records ?how wil you do what logic to implement?
- 7 Answers
- 11724 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 |
Plz..let me know differences between Informatica 7.1 and 8.1?
Aggregator transformation is having fields say a,b,c,d,e group by is enabled on a,b,c with sorted input,How the aggregator transformation process the i/p data?or in which way i/p comes to agg transformation
How mapping parameter and variable works
i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.
what are the types of Data warehousing ?
Under which circumstances, informatica server creates reject files?
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to vanibv6@gmail.com Thnx Vani
if the column name in sql override is diff from the column name in source qualifier,what is the impact?
What are the measure objects?
What is a pre-defined event and user-defined event?
Hi all,Can any one provide me Informatica Designer Certification dumps.I need all three papers dumps.If any one has these dumps then plz send it on this id:- nagesh.jujjuru@yahoo.com Thanks in advance
While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?
Teradata 
