What is the Environment Variable need to Set to TRIM in
Project Level?(In transfermer, we TRIM function but I need
to impliment this project level using Environment variable)
No Answer is Posted For this Question
Be the First to Post Answer
This is UNIX question asked in DataStage Interview. Say I have n numbers of records in a text file. I want first 3 records in 1st file, last three records in 3rd file and remaining n-6 records in 2nd file. (Note: we don't know how many records are there in the File. I am getting one file on daily basis and I want three target files as asked above)
create a job to get the previous row salary for the current row.if there is no previous row exists for the current row,then the previous row salary should be displayed as null? empid salary previoussalary 10 1000 null 20 2000 1000 30 3000 2000 40 4000 3000
project Steps,hits, Project level HArd things,Solved methods?
source which format u will get either fixed or delimiter length format? what is the symbol of delimiter?
whom do you report?
What is orabulk stage?
Is there any possibility to generate alphanumeric surrogate key?
diff between OLTP and OLAP? what TOP-DOWN and BOTTOM-UP Approach? which is best? what are Star Schema and Snow Flake Schema?
What's the Main Function of the Staging area in DWH
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
Suppose take my name "Reddyvaraprasad" From source it is coming Reddy vara prasad Need to get As Reddyvara prasad/
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
0 Answers Alpharithm Technologies,