With out using Funnel Stage, how to populate the data from
different sources to single target
Answer Posted / sagar
better use join stage kiran,bcause join stage accepts
toretrive the records from different stages,and also join
accepts many inputs and one output link.so dis stage can
satisfies ur condition.and also ihave to say merge,lookup
accepts rejects u need one target so join will satisfies....
ur's
sagar
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
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
How to read the length of word in unix?
How do you reject records in a transformer?
What is the difference between operational data stage (ods) and data warehouse?
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
What are the types of hashed files in data stage
How to Remove Duplicate using SQL?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
Name the different sorting methods in datastage.
How to perform incremental load in datastage?
What are the types of containers in datastage?
What is a merge?
What is quality stage?
Why do you need stage variables?