Interested to Buy Any Domain ? << Click Here >> for more details...
I have a source table with column name CITY having 100
records,
I want target table with column name start with 'A'
and 'B',remaining columns as reject outputs.
how can achieve this by data stage?please help me?????
- 5 Answers
- 12542 Views
- I also Faced
- E-Mail Answers
Answer Posted / bg
Job design will be:
seq --- Tx ---- target.txt
|_____ reject.txt
IN transformer use below constraint for target.txt
Left(city,1)='A' or Left(city,1)='B'
Check the otherwise and send it to reject file.
| Is This Answer Correct ? | 22 Yes | 0 No |
Post New Answer View All Answers
Can you explain kafka connector?
What is aggtorec restructure operator?
How do y read Sequential file from job control?
What is the difference between informatica and datastage?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
What are the various kinds of containers available in datastage?
What are the main differences you have observed between 7.x and 8.x version of datastage?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
how do u catch bad rows from OCI stage? And what CLI stands for?
What is oci?
State the difference between an operational datastage and a data warehouse?
What are sequencers?
Can you explain repository tables in datastage?
Define meta stage?
