I have file with empid,empname and I want to load these two
fields along with sal in my target
1)salary must be same for all the records
2)I want pass the salary at run time
Answer Posted / sirisha
by using transformer stage also we can generate the column &
values also
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
Define APT_CONFIG in Datastage?
What are orabulk and bcp stages?
What are transforms and what is the differenece between routines and transforms?
Differentiate between validated and Compiled in the Datastage?
How do you remove duplicate values in datastage?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
What is the difference between an operational datastage and a data warehouse?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
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.
Differentiate between data file and descriptor file?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
Triggers,VIEW,Procedures
How you Implemented SCD Type 1 & Type 2 in your project?