data stores in which location while using data set stage as the target?
Answer / srini
The Dataset stage contains Two files one is Descriptor and
the other is Data file.Usually what we give in the file
path contains the Descriptor file and actual data will be
stoerd in the Data file with has same name but with Number
of partitions as the suffix in u r job.The location will
the what u mentioned in the config file for Resource disk.
| Is This Answer Correct ? | 13 Yes | 0 No |
I am having the 2 source files A and B and I want to get the output as, the data which is in file A and which doesn't in file B to a target 1 and which is in file B and which doesn't in file A to a target 2?
Give example for FACTLESS FACT TABLE in real-time scenario.
Why do you need stage variables?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
1.What is the flow of Transformer? 2.How can you do INDEX table in DataStage level?
what is combinability and non combinability?
input Name Salay Sam 10 Sam 30 Sam 20 Ram 40 Ram 50 Output should be Name Salary Count Sam 10 3 Ram 40 2 get min salary and count of name . OutPut 2 Name Seq Sam 1 Sam 2 Sam 3 Ram 1 Ram 2
Differentiate between odbc and drs stage?
What's the Main Function of the Staging area in DWH
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?
why we use parameters instead of hard code in datastage
What are the types of containers in datastage?