Can we use sequential file as source to hash file? Have you
do it ?if what error it will give?
Answer / srinivas
We can use sequential file as source for hash file it doesnt give any error .
If have any doubt try once.
| Is This Answer Correct ? | 0 Yes | 0 No |
How to remove ctrl M or(^M) characters in file using Sequential File stage?
2 Answers Bank Of America, Satyam,
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?
What is the use of datastage designer?
where we use column generator stage in real time scenario?
Where the datastage stored his repository?
what is the use of invokation id
Explain usage analysis in datastage?
I have 2 files 1st contains duplicate records only, 2nd file contains Unique records.EX: File1: 1 subhash 10000 1 subhash 10000 2 raju 20000 2 raju 20000 3 chandra 30000 3 chandra 30000 File2: 1 subhash 10000 5 pawan 15000 7 reddy 25000 3 chandra 30000 Output file:-- capture all the duplicates in both file with count. 1 subhash 10000 3 1 subhash 10000 3 1 subhash 10000 3 2 raju 20000 2 2 raju 20000 2 3 chandra 30000 3 3 chandra 30000 3 3 chandra 30000 3
what is initial load and incremental load
What is the flow of loading data into fact & dimensional tables?
DataStage Scenario based Interview Questions
plz tell me some dimentional and fact table names in banking project?