Experts In Informatica/sql/shellscripting

[venky29]

hi fellas welcome all im new to informatica so skills imporvisation ki already exp persons help kavali

scenarios ivvandi i will try to solve them not online ones need konchem realtime related ones

 

alage unix scripts konchem weak exp people guide me to improve those konchem sql kuda

 

thanks in advance db experts answers kosam waiting mee junior

[150bryant]

how to dynamically code to get current years data only ?

oka table 2010 2011 2012 2013 2014 data. undhi.

write a code...tht will give only current years data/

 

where Date = 2014 ani use cheyochu..but thts not the way to code

[Srinidhi]

We have a source table containing 3 columns : Col1, Col2 and Col3. There is only 1 row in the table as follows:

 

Col1         Col2         Col3

a         b         c

 

There is target table containg only 1 column Col. Design a mapping so that the target table contains 3 rows as follows:

 

Col

a

b

c

[Srinidhi]

Split the non-key columns to separate tables with key column in both  / How to split the data of source table column-wise with respect to primary key.

[Srinidhi]

Segregate the duplicate and distinct rows from source table to separate target tables

[jaffanajeffada]

:4_12_13:

[Srinidhi]

How to get first and last record from a table/file?

[Srinidhi]

How to remove footer from your file ?

 

For example the file content looks like as below:-

 

some Header here

col1    col2    col3     col4

data1  data2  data3  data4

data5  data6  data7  data8

data1  data2  data3  data4

data1  data2  data3  data4

footer

Just we have to remove footer  from the file.

[Srinidhi]

How to send first half record to target?

[Srinidhi]

Send Odd numbered records to one target and even numbered records to another target.

[Srinidhi]

There is a source table and 3 destination tables T1,T2, T3. How  to insert 1 to 10 record in T1, records from 11 to 20 in T2 and 21 to 30 in T3.Then again from 31 to 40 into T1, 41 to 50 in T2 and 51 to 60 in T3 and so on i.e in cyclic order.

[Silver_mani]

how to dynamically code to get current years data only ?

oka table 2010 2011 2012 2013 2014 data. undhi.

write a code...tht will give only current years data/

 

where Date = 2014 ani use cheyochu..but thts not the way to code

 

nenu cheppocha adyaksha ?

[gabbarsingh1]

Send Odd numbered records to one target and even numbered records to another target.

 

oka dani tarvatha okati anta... anni oke sari ante.. confuse aipothadu :3D_Smiles:

[gabbarsingh1]

nenu cheppocha adyaksha ?

 

karchu aithadi...

[Srinidhi]

oka dani tarvatha okati anta... anni oke sari ante.. confuse aipothadu :3D_Smiles:

alaga ani neetho cheppada