With out using Funnel Stage, how to populate the data from
different sources to single target
Answer Posted / gourav
using merge, join or lookup stage.
| Is This Answer Correct ? | 8 Yes | 4 No |
Post New Answer View All Answers
How to implement complex jobs in data stage?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
Differentiate between Join, Merge and Lookup stage?
On which Dimension Table you implemented SCD Type in your Project
what is 'reconsideration error' and how can i respond to this error and how to debug this
what is the use of materialized view?
what is repositery?
What is the precedence of stage variables,derivations, and constraints?
What is the different type of jobs in datastage?
What are the different plug-ins stages used in your projects?
how to write server Routine coding?
What is apt_config in datastage?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do