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
- 12636 Views
- I also Faced
- E-Mail Answers
Answer Posted / satish
Job design will be:
seq --- Tx ---- target.txt
------rejct.txt
IN transformer use below constraint for target.txt
Left(city,1)='A' or Left(city,1)='B'
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is the difference between the local container and shared container?
On which Dimension Table you implemented SCD Type in your Project
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
Highlight the main features of datastage?
CHANGE CAPTURE
Describe link sort?
client know skid info?
What is the roundrobin collector?
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
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
What are stage variables and constants?
in oracle target stage when we use load option and when we use upsert option?
Give an idea of system variables.
How we can covert server job to a parallel job?
What are the main features of datastage?
