Interested to Buy Any Domain ? << Click Here >> for more details...
How can i generate Seqence Numbers to Tagret Table
(with out using Seqence Gen Trans,Rank Trans).
- 5 Answers
- 10284 Views
- I also Faced
- E-Mail Answers
Answer Posted / ganesh
You can handed this issue, using expression transformation.
1) create one variable port and declare it as Integer and
assign the value to Output port.
e.g: var_count Integer var_count+1
out_count Integer var_count
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Repository user profiles
Where is metadata stored?
what are 3 tech challenges/ common issues you face?
What is meant by a domain?
What is DR strategy for Informatica project?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What is the reusable transformation?
How are indexes created after completing the load process?
What is a sorter transformation?
Mention few power centre client applications with their basic purpose?
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?
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
What are the reusable transformations?
How to extract the informatica rejected data?
Explain the mapping variable usage example in informatica
