i/p o/p1 o/p2 1 1 4 1 1 5 1 1 6 2 2 2 2 2 2 3 3 4 5 6 how to populates i/p rows into o/p1&o/p2 using datastage stages?and also the same scenario using sql?
IBM,
8 112211)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)
23011.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
IBM,
1795Source contains the metadata source ----- hyderabad,chennai,bangalore by using nested loop sequence select source as hyderabad in target just run target as hyderabad only not others please give me answer thanks in advance(give reply how to wrote logic using nested loop sequence)
IBM,
1 2740explain how to create SCD-2 IN DATASTAGE 7.5X2 PLZ EXPLAIN WITH 4 OR 5 RECORDS TAKE IT EXAMPLE AND JOB DESINGN URGENT
3 11051
Define Data Stage?
Differentiate between operational datastage (ods) and data warehouse?
Is the value of staging variable stored temporarily or permanently?
Difference between sequential file and data set?
What are the various kinds of the hash file?
How to read multiple files using a single datastage job if files have the same metadata?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
whom do you report?
What are the enhancements made in datastage 7.5 compare with 7.0?
Can you define merge?
How do you import and export the datastage jobs?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
What are the different layers in the information server architecture?
What are stage variables and constants?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?