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
No Answer is Posted For this Question
Be the First to Post Answer
How do you find the number of rows in a sequential file?
How do you get log info into a file?
Can you highlight the main features of ibm infosphere information server?
What is a folder? Difference types of stages?
If I make any changes in the parallel job,do I need to implement the changes in the sequencer job,else the changes will be reflected automatically
insequential file 2header avaliable,and 100 records avaliable.how to skip the 2 headers and load 100 records target?
Source have 1000 records and it can have three nodes ok but i want how many records are executed on each node?
how to find diff between 2 dates without using Icon... funtions?
Differentiate between Join, Merge and Lookup stage?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
What is a merge in datastage?