how do you pass parameters in a script?
Answer / sriharsha vemuri
dsjob -run -wait -param <parmeterset>.<var>=<value to
assign> <projectname> <jobname>;
| Is This Answer Correct ? | 1 Yes | 2 No |
Triggers,VIEW,Procedures
How do you load 10 different sources with 10 different layouts to 10 different tables?
What are the types of containers and how to create them?
how to call routines in stages?
Name the third party tools that can be used in datastage?
Define data aggregation?
Wat is isolation level and when do u use them?
how to delete one row in target dataset
Converting Vertical PIVOTing without using PIVOT stage in DataStage. Ex: DEPT_NO EMPNAME 10 Subhash 10 Suresh 10 sravs Output: DEPT_NO EMP1 EMP2 EMP3 10 subhash suresh sravs 2) How to implement Horizontal PIVOTing without using PIVOT stage.
Unix Qn asked in datastage interview: I have diff type(.txt, .tmp, .bat etc) of file in 4 diff directories, I want move all '.txt' file from 4 directories to other folder. And need to delete all the files except which are created TODAY?
HOW CAN YOU DO SCD2 IN DATA STAGE USING SEQUENTIAL FILES?
What are the different common services in datastage?