Interested to Buy Any Domain ? << Click Here >> for more details...
Hi ,
Please help how to achieve the following scenario.
I have a source table like this.
Rollno name class university
1 Raj 1st Sku
2 Ram 2nd SVU
3 Sam 3rd OU
I need the data in the target table like below.
Rollno name class university
1 Raj 1st Sku
2 Ram 2nd SVU
3 Sam 3rd OU
4 Rajesh 5th SKU
The Last row values we have.. and we have to append this
last row in the target table.
Thanks and Regards
Nataraj V
- 3 Answers
- 7232 Views
- NTT Data, I also Faced
- E-Mail Answers
Answer Posted / harleen
The question needs to be corrected.I think there are 3 rows already in the target and only one row has to be inserted.
The same can be done by 2 ways
1)Update strategy (Update as Insert)
2)Dynamic lookup
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
generate date / time dimension in informatica
can we override a native sql query within informatica? How do we do it?
What is meant by incremental aggregation?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What are pre and post-session shell commands?
In development project what is the process to follow for an etl developer from day1
What is the difference between informatica 7.0 and 8.0?
Why is sorter an active transformation?
How to join three sources using joiner?
Is it possible to use a client with different version than that of its Informatica server?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Where is metadata stored?
What is aggregate cache in aggregator transformation?
