Answer Posted / amulya kumar panda
In transformer stage has system variable and select
@INROWNUM <10000
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
What can we do with datastage director?
What are transforms and what is the differenece between routines and transforms?
Can you explain repository tables in datastage?
What are the primary usages of datastage tool?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
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?
How can you write parallel routines in datastage PX?
what is the use of skid in reporting?
What is size of a transaction and an array means in a datastage?
how do u catch bad rows from OCI stage? And what CLI stands for?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
What is the purpose of interprocessor stage in server jobs?
What are sequencers?