How to use Environment variable's in datastage?(use of process)
To use environment variable at the project or job level, we
should first check if the environment variable already
present at the project level. If the environment variable
does not exist, we should create the one and then it should
be used at the project level or at the job level.
To use the environment variable you just need to add to the
project or job.
Is This Answer Correct ? | 2 Yes | 3 No |
On which interface you will be working as a developer?
How can one find bugs in job sequence?
Define Merge?
how to add a new records into source?
Give example for FACTLESS FACT TABLE in real-time scenario.
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
source has 2 fields like COMPANY LOCATION IBM HYD TCS BAN IBM CHE HCL HYD TCS CHE IBM BAN HCL BAN HCL CHE LIKE THIS....... AND I WILL GET THE OUTPUT LIKE THIS.... Company loc count TCS HYD 3 BAN CHE IBM HYD 3 BAN CHE HCL HYD 3 BAN CHE PLZ SEND ME ANSWER FOR THIS QUESTION..........
what is materialized view used datastage?
how to get the unique records on multiple columns by using sequential file stage only
what is the difference between the join and look up explin me one exmple
Hi frnds, my scenario is like i'm having a record 1234"1323£3434%343434^23232!1212$23232 in the above record all the special characters must be removed.how can we do it in datastage 8.0.1.can any one please ans this? thanx in advance
How can we move a DATASTAGE JOB from Development to Testing environment with the help of a datastage job using unix commands.