DataStage Scenario #6 - Populate 'Not Found'
Atul Singh
September 29, 2015
Scenario: Design a job which read a flat file and populate the output as NOT FOUND which is not available in the other file. Exa...
Tuesday, September 29, 2015
Monday, September 28, 2015
Tips - DataStage Annotation Stage is disabled or grayed out
Atul Singh
September 28, 2015
Sometimes, we have faced this problem that Annotation and Description Annotation is disabled or grayed out and we are unable to use it in ...
Friday, September 25, 2015
5 Tips for better DataStage Design #1
Atul Singh
September 25, 2015
01. Always try to complete the requirement first, Don't spoil your time to develop an optimized job which is practically useless unti...
Thursday, September 24, 2015
Informatica Server Variables Default Values
Atul Singh
September 24, 2015
Domain --> select Integration Service(IS)-->Processes--> General Properties and then edit the relevant properies to point corr...
Wednesday, September 23, 2015
Shell Script Scenario #6 - Shuffle the input
Atul Singh
September 23, 2015
- Design a shell script which take some character or number or string as a input separated by space and generate a shuffled output from th...
Tuesday, September 22, 2015
Linux Shell Script Scenario #4
Atul Singh
September 22, 2015
- Create a script which counts the number of users currently logged in. - Create a script which backs up all the dotfiles for the curren...
Monday, September 21, 2015
DataStage Scenario #5 - Oracle Rank & Rownum
Atul Singh
September 21, 2015
Scenario: a. Design a job where we read the data from squential file. b. Analyze the data into job and generate these 3 columns E...
Monday, September 14, 2015
DataStage Scenario #2 - Find Palindrome Number
Atul Singh
September 14, 2015
Develop a datastage job to identify whether input data is a palindrome number or not, If it is, need to print the output as below - ...
Friday, September 11, 2015
Linux Shell Script Scenario #3
Atul Singh
September 11, 2015
Design a Shell Script which have to work for below scenario :- We are having two files, File1 is having a 20,000 lines of data an...
Column auto mapping in Informatica
Atul Singh
September 11, 2015
Informatica PowerCenter Designer can automatically link ports ( Columns) between transformations both by position and by name. Go to Man...
