Tell me Wt main advantage of Stage varibles?
Project level hints?

Answer Posted / brajesh

1. it can be used as global variable
2. It can be used for some preproceesiing operation
required for some constarint or records(columns).
3.It can be used to store the previous rows processed data
which can be used by next coming row.( its one of the
programming tactic )
Also the order of stage variable matters , it will execute
in the order they apeared on its palate.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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)

2301


file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

521


What is the difference between hashfile and sequential file?

703


Can you explain tagbatch restructure operator?

687


What is usage analysis in datastage?

795






How can one find bugs in job sequence?

771


explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

1914


How to convert RGB Value to Hexadecimal values in datastage?

3442


What are the types of views in datastage director?

1234


Can you explain kafka connector?

761


To see hidden files in LINIX?

937


What is the difference between informatica and datastage?

642


1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

1619


Nls stands for what in datastage?

716


Enlist various types of routines in datastage.

634