Source contains the metadata
source
-----
hyderabad,chennai,bangalore by using nested loop sequence
select source as hyderabad in target just run target as
hyderabad only not others please give me answer thanks in
advance(give reply how to wrote logic using nested loop
sequence)
Answer Posted / shiva
Please put your requirement clearly
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to reverse the string using SQL?
Difference between in process and inter process?
What steps should be taken to improve Datastage jobs?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
What is merge stage?
Can you explain link buffering?
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 the ipc stage work?
What are the various kinds of containers available in datastage?
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
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
Describe stream connector?
What is the difference between the local container and shared container?
Difference between server jobs & parallel jobs?