Showing posts with label Column. Show all posts
Showing posts with label Column. Show all posts

Monday, 7 November 2016

Modify Stage - Drop Columns

Wednesday, 14 October 2015

DataStage Scenario #7 - Count data in each column


Count the total rows and cells which is having some data in it.





Input:

col1 col2 col3
 a {NULL} b
f k {NULL}
h {NULL} n
i d {NULL}
{NULL} s {NULL}
g u m
l x o
m {NULL} {NULL}
c d z



Output:

Count Rows Count_col1 Count_col2 Count_col3
9 8 6 5





Like the below page to get update  
https://www.facebook.com/datastage4you
https://twitter.com/datagenx
https://plus.google.com/+AtulSingh0/posts
https://groups.google.com/forum/#!forum/datagenx

Friday, 11 September 2015

Column auto mapping in Informatica



Informatica PowerCenter Designer can automatically link ports ( Columns) between transformations both by position and by name.

Go to Manu bar --> click Layout > Autolink by Name ( Or Autolink by position)
select the mapping object that you want to link (e.g. source) and drag the selected ports to another mapping object ( e.g. target)





Like the below page to get update  
https://www.facebook.com/datastage4you
https://twitter.com/datagenx
https://plus.google.com/+AtulSingh0/posts
https://groups.google.com/forum/#!forum/datagenx

Thursday, 3 September 2015

DataStage Scenario #3 - Fetch middle one



Develop a DataStage Job to achieve below requirement -




Input:
Single_Column
Atul Kr Singh
Geeta Vishwas
Anoop Despande
Rohit S Pande
Ankit Singh
Garima Bhatia Arya


Output:
Fname   Mname   Lname
Atul       Kr         Singh
Geeta                  Vishwas
Anoop                 Despande
Rohit     S           Pande
Ankit                  Singh
Garima   Bhatia   Arya


For more Scenario -  CLICK HERE