Sequential file i have one record,i want 100 records in target?How can we do that?Pls explain me and what stages are there?What logic?
Answer / teju
take source sequential file with 1 rec and take target file with 100 records in between use a copy stage to map the source 1 rec to target 100 records.
Is This Answer Correct ? | 0 Yes | 0 No |
How many Key we can define in remove duplicate stage?
Explain the importance of surrogate key in data warehousing?
What is meta stage?
guys pls tell me where we use sequence jobs exactly in realtime proj explain pls with example.
How to convert table data into xml file using xml output stage? please explain step by step;
Source contains the metadata source ----- hyderabad,chennai,bangalore by using nested loop sequence select source as hyderabad in target just run target as hyderabad only not others please give me answer thanks in advance(give reply how to wrote logic using nested loop sequence)
project Steps,hits, Project level HArd things,Solved methods?
Explain the scenarios where sequential file stage runs in parallel?
Hi friends, I am new to datastage, i have one query in datastage any one you please give reply to my post. I have a workbook (excel sheet) named as eg: xxxx, in that i have two tables emp(eid, ename, salary, deptno) and dep(deptno, name, state). in my source i have ODBC enterprise stage read the emp table and dept table join the two table and write the dept no 10(eid,ename,salary,name,state) values in target(). Thanks, Badari
if 3 table having different columes. like first table having 4 columns , second table having 3 columns and third table having 2 columns then how to capture the data by using funnel stage in parallel jobs...srinu.thadi
17 Answers IBM, TCS,
How a server job can be converted to a parallel job?
Tell me Wt main advantage of Stage varibles? Project level hints?