Hi this madan, in data stage one file in Empno 12345678910 in a table, i want target is
Empno
1
2
3
4
5
6
7
8
9
10
Answer Posted / prasad
yo ca use while loop to get this output take two loop variables one is for condtion in condition you should write like variable<=len(inputlink.string) and in loop variable use inputlink(indexnum,1) then you will get output like what you wanted
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between server job and parallel jobs?
What is size of a transaction and an array means in a datastage?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
What are the types of hashed files in data stage
Name the command line functions to import and export the DS jobs?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
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
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
Differentiate between validated and Compiled in the Datastage?
How do you start developing a datastage project?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
I have a few records just I want to store data in to targets cycling way how?
what is flow of project?
How do you run datastage job from the command line?
Is it possible to query a hash file?