i have n number of records in my source, i want first and
last record to my target. how can u implement this scenario .
- 6 Answers
- 8044 Views
- Emphasis, I also Faced
- E-Mail Answers
Answer Posted / srinivas bolusupati
Use sequence generator t/r and give the nextval link
to 2 rank transformations, 1st one with top1 and 2nd one with bottom1 and connect them to 2 instances of target..
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is a shortcut and copy in Informatica and how two are different with each other?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What are Dimensional table?
Is there any target staging area in informatica not staging area
Can you use flat files in Mapplets.
lookup transformation with screenshots
What are the types of caches in lookup?
How to implement security measures using repository manager?
What is a dimensional model?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
Explain about Informatica server process that how it works relates to mapping variables?
