where we use column generator stage in real time scenario?
Answer Posted / yarramasu
If u have two tables that are a and b. A table have two
columns and b table have 3 columns in two tables are
metadata to be same that time we can use column generator
stage for getting total columns in a target
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Which warehouse using in your datawarehouse
CHANGE CAPTURE
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
What are the types of containers in datastage?
What is quality stage?
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
How to read multiple files using a single datastage job if files have the same metadata?
Triggers,VIEW,Procedures
Can you filter data in hashed file?
If you want to use the same piece of code in different jobs, how will you achieve it?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
How do you reject records in a transformer?
What is the use of datastage designer?
What is the different type of jobs in datastage?
Explain the situation where you have applied SCD in your project?