Interested to Buy Any Domain ? << Click Here >> for more details...
5) A file contains 10 (1-10) I want trgt like
Trgt 1 trgt 2 trgt 3
1 2 3
4 5 6
7 8 9
10
- 4 Answers
- 8901 Views
- I also Faced
- E-Mail Answers
Answer Posted / joe
we can use a transformer with constraint mod(@INROWNUM,3)=2
for trgt1,, =1 for Trgt2, =3 for Trgt3
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
What are orabulk and bcp stages?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
Name the different types of Lookups in Datastage?
What is usage analysis in datastage?
What is ibm datastage?
How do you import and export the datastage jobs?
Where the datastage stored his repository?
Notification Activity
What is the importance of the exception activity in datastage?
Which warehouse using in your datawarehouse
How do y read Sequential file from job control?
Different ways a project can be moved to production ?...example ….export-import and Version control.
What is a datastage job?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
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)
