Urgent Help Needed

[vicky2]

[quote author=vijay rocking link=topic=155862.msg1845692#msg1845692 date=1297735921]
use the words mention above and explain same project.

Get the data from AS/400 systems(most of the banks use this), and flat files from citi bank, which is in encrypted format, we use java classes and java tranfrormation to decrypt those flat files and load into bank's datawarehouse oracle tables.

worked on integration project, which the data comes from capital markets and correspondent systems.

and this is financial, should be daily refresh....

and extract the data from bank's different data sources.  Create comma delimited flat files, encrypt them and send it to different financial vendors through secure ftp




[/quote]


Dude One more question
1. Can you tell me 2 or more Scenarios in which we use storedprocedure and triggers.
2. Can you tell me 2 or more Scenarios in which we use unix commands like Grep and Sed.
3. Can you tell me the complex mapping which you use.

Responses are appreciated

[vicky2]

[quote author=bing link=topic=155862.msg1845867#msg1845867 date=1297737496]
sorry2,but atb
[/quote]


Thanks Dude

[vijay rocking]

[quote author=vicky2 link=topic=155862.msg1845922#msg1845922 date=1297737918]

Dude One more question
1. Can you tell me 2 or more Scenarios in which we use storedprocedure and triggers.
2. Can you tell me 2 or more Scenarios in which we use unix commands like Grep and Sed.
3. Can you tell me the complex mapping which you use.

Responses are appreciated
[/quote]

1. Stored procudere-- to call Truncate table or update table stored procuderes. Triggers- to update history table automatically.

2. Grep-to find and rename files in local or remote directory.  ex: file1_10202010.txt to file_1.txt.  Sed:  To replace the character, count the number of records in file. archiving the files in archive directory.

3. Example getting 8 borrower information in one record, which is the SSN is in encrypted.
    Load the borrower information individually in separate records. use rank, normalizer and decrypt SSN, use java transformation.... etc..............

[graham]

[quote author=vijay rocking link=topic=155862.msg1846015#msg1846015 date=1297738527]
1. Stored procudere-- to call Truncate table or update table stored procuderes. Triggers- to update history table automatically.

2. Grep-to find and rename files in local or remote directory.  ex: file1_10202010.txt to file_1.txt.  Sed:  To replace the character, count the number of records in file. archiving the files in archive directory.

3. Example getting 8 borrower information in one record, which is the SSN is in encrypted.
    Load the borrower information individually in separate records. use rank, normalizer and decrypt SSN, use java transformation.... etc..............
[/quote]

you rock you rock you rock *=:

[vicky2]

[quote author=vijay rocking link=topic=155862.msg1846015#msg1846015 date=1297738527]
1. Stored procudere-- to call Truncate table or update table stored procuderes. Triggers- to update history table automatically.

2. Grep-to find and rename files in local or remote directory.  ex: file1_10202010.txt to file_1.txt.  Sed:  To replace the character, count the number of records in file. archiving the files in archive directory.

3. Example getting 8 borrower information in one record, which is the SSN is in encrypted.
    Load the borrower information individually in separate records. use rank, normalizer and decrypt SSN, use java transformation.... etc..............
[/quote]
thankyou

[vijay rocking]

[quote author=MICKEY link=topic=155862.msg1846039#msg1846039 date=1297738689]
you rock you rock you rock *=:
[/quote]
thankyou thankyou