Powered By Blogger

Wednesday, June 6, 2012

Things to verify...


Lookup Over-ride as clause and port map
Un-connected Lookup Input
Session Variables use
Indirect File Read What if select has more columns that ports available at Lookup and Source Qualifier 

XML of mapping, session, workflow
Mapping, Session, Workflow parameter and variable working
What all things we can parameteriazed ?
Interview Question of Records count - use of aggregator and joiner, second answer to earlier question.
Normalizer, want to trasfer 2 colums as 2 rows. But rest all columns are same
Issue of performance related to birwarkar
in what order we need to perform order by at lookup over-ride
auto option of memory...
full outer join of joiner 

Unix:
 grep "NK2" RDBJANERMM_BRK2_20110916_L1_20110917013839_risk.csv |  grep "USD" | cut -d"," -f3 | uniq

1) Command for listing only the files with some data =>
 find . -size +0c -ls | grep BFE2

2) Command for listing all the files but sorted according to their Size =>
 ls -lrS | grep BFE2
3) To convert "," to ";" fron whole file
First open the file using => view temp.csv
 %s/,/;/g
4) To display 12th colum from a .csv file, with condition that file "risk.csv" contains "EQUIP:ATFV"
 grep "EQUIP:ATFV" risk.csv | cut -d"," -f12
5) To view only directories
  ls -lrt | grep ^d
6) To delete roes from 3 to 17 in vi editor
 3,17d
7) To delete a row in vi editor
 press d twice with the cursor in the row to be deleted.

No comments: