How to load only the first and last record of a flat file into
the target?
- 3 Answers
- 8818 Views
- Mind Tree, I also Faced
- E-Mail Answers
Answer Posted / yaseen
After SQ place 2 Rank T/R and a reusable sequence generator T/R having start value 1. In 1st Rank give the top 1 and in 2nd Rank set bottom 1
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
How to delete duplicate row using informatica?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Plz can any one say me how to get the informatica certification materials and dumps
What is rank transform?
How do you load unique records into one target table and duplicate records into a different target table?
What is lookup transformation?
Explain load alternative records / rows into multiple targets - informatica
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
What are the new features of Power Center 5.0?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What is meant by active and passive transformation?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What are the informatica performance improvement tips
How to load a Dimension ? and how to load a fact table?
