Ssis Data Warehouse Valu Oka Sari Itu Randi......

[ghazni]

Just miru chestuna scenarios cheptara....... data validation, data cleasing....... naku untey f2f untadi...... plz help........

[ghazni]

[JUJUBI_JULABI]

req endi , warehouse unda ?

[ghazni]

[quote name='JUJUBI_JULABI' timestamp='1345148832' post='1302321636']
req endi , warehouse unda ?
[/quote]
yeah avunu data warehouse ani undi..... Development tasks involve extracting data from a staging area transforming data to the sql server datawarehouse........

[ghazni]

[ChampakDas]

[tom bhayya]

[_poori]

[ghazni]

enti okaru kuda lera DB la...... sare le na badalu nenu padta.....

[Darling999]

What you used to do in previous proj antey?

Sol:

We had few legacy systems like Oracle, Teradata, and sometimes files like .txt and Excel from users.
My role was to get the data from Legacy to our DB using SSIS: Here tell them than you wrote different packages for transfer.
After Getting the data we need to transform it according to Business requirements and Logics, these were Implemented in SSIS using different components.

Wat have you used from above ani adigitey: in Dataflow: I sued Lookup, ConditionalSplit, File system, Oldeb SOurce and destination for connections, Foreach loop, Mail, Execute SQl in COntrol flow(dont just limit to these but also tell them if you know any more). After the Logics are applied in these Packages, data used to flow into Text files for users.

if they ask you: how did you send the files to them, then say you used FTP task for the Transfer to remote location.

if they ask you: Any issues while you developed the packages antey tell them dat you had datatype issues as transfer was from different legacies to our systems.

regarding components: use this Link for reference yoiu should be good. Ask me if you have any more Questions. I will help you.

Note: this is a simple scenario in real time.

ATB

[Darling999]

[quote name='ghazni' timestamp='1345166274' post='1302323252']
enti okaru kuda lera DB la...... sare le na badalu nenu padta.....
[/quote]
unnava poyinava

[ghazni]

[quote name='DARLING...' timestamp='1345166363' post='1302323267']
What you used to do in previous proj antey?

Sol:

We had few legacy systems like Oracle, Teradata, and sometimes files like .txt and Excel from users.
My role was to get the data from Legacy to our DB using SSIS: Here tell them than you wrote different packages for transfer.
After Getting the data we need to transform it according to Business requirements and Logics, these were Implemented in SSIS using different components.

Wat have you used from above ani adigitey: in Dataflow: I sued Lookup, ConditionalSplit, File system, Oldeb SOurce and destination for connections, Foreach loop, Mail, Execute SQl in COntrol flow(dont just limit to these but also tell them if you know any more). After the Logics are applied in these Packages, data used to flow into Text files for users.

if they ask you: how did you send the files to them, then say you used FTP task for the Transfer to remote location.

if they ask you: Any issues while you developed the packages antey tell them dat you had datatype issues as transfer was from different legacies to our systems.

regarding components: use this Link for reference yoiu should be good. Ask me if you have any more Questions. I will help you.

Note: this is a simple scenario in real time.

ATB
[/quote]
thanks dude.......naku ee outer structure motam konchem idea undi mama....... problem entnatey koni scenarios adugutunaru alntivi konchem chepagalava......

nuvu chepav kada wat problems u facedani alantivi inka neeku emana vachi vuntey share chesuko mama........

[Darling999]

[quote name='ghazni' timestamp='1345166845' post='1302323322']
thanks dude.......naku ee outer structure motam konchem idea undi mama....... problem entnatey koni scenarios adugutunaru alntivi konchem chepagalava......

nuvu chepav kada wat problems u facedani alantivi inka neeku emana vachi vuntey share chesuko mama........
[/quote]
eppudundi neeku interview, repu morning office ki elli raastaa, PM once

[ghazni]

[quote name='DARLING...' timestamp='1345166968' post='1302323340']
eppudundi neeku interview, repu morning office ki elli raastaa, PM once
[/quote]
thanks mama ala anna annav....... next untey untadi kani confirm kaledu......... so ee weekend motam anni tasks chedamani decide ayina............

[Darling999]

Calling ghazni.[img]http://lh5.ggpht.com/-CHwosn5NOa0/ToJcQX7NNAI/AAAAAAAAEfY/-qT6f0d7Liw/s150/PK-5.gif [/img]..