how to fetch the last row from a particular column.. Input file may be sequential file...
Latest Answer: Develop a job source seq file--> Transformer--> output stageIn the transformer write a stage variable as rowcount with the following derivationGoto DSfunctions click on DSGetLinkInfo..you will get "DSGetLinkInfo(DSJ.ME,%Arg2%,%Arg3%,%Arg4%)" Arg ...
Using server job, how to transform data in XML file into sequential file?? i have used XML input, XML transformer and a sequential file.
Latest Answer: Import the XSD for the xml file via manager-metadata importer and store it. If transformation functions are not required to be done on the data in XML file, there is no need for the transformer. To load data directly from a XML file to ...
I am eager to know about DataStage Engine commands. Can someone tell me something about that?
Latest Answer: the following commands can be taken as DS Engine commands, used to start and stop the DS EngineDSHOME/bin/uv -admin -startDSHOME/bin/uv -admin -stop ...
What is the purpose of Debugging stages? In real time Where we will use?
Latest Answer: hi the main use of Debugging Stages(row gen,peak,tail,head etc) are they are help full to monitor jobs,and they generate mock data wen we dont have real time data to test ...
What is the difference between change capture and change apply stages
Latest Answer: Change capture stage is used to get the difference between two sources i.e. after dataset and before dataset. The source which is used as a reference to capture the changes is called after dataset. The source in which we are looking for the change is ...
What is the Disadvantage of surrogate key stage?
Latest Answer: to my concern if the data is not properly processed on nodes..in such suitations this surrogate key generates holes(simply skips the ordering )ex:aa-1bb-2ba..bg...cc-3dd-4ddd-5here for ba and bg do not have seq key ,here ba and bg have holes ...
how to find out individual counts for a particular table
Latest Answer: while implementing the scd type-2, due to maintianing of history, the primary key constraint will be violated. to have a primary key for the table for the sake of unique key we use surrogate key. ...
Any body explain the flow of project(parallel) in real time thanx
1. Is the Hash file is active or passive? If we take as source ?2. can u take seq file as look up?3. In hash file dynamic 30, there r two types:1)genaric2)specific what is the meaning?4. how to connect
Latest Answer: can you please explain me for which question you didn't get the answer? ...
View page << Previous 1 [2] 3 4 5 6 7 8 9 10 Next >>
Go Top
