| |
|
| SITE BEST VIEW |
Hai viewers , please set your computer resolution to 1024 by 768 to enjoy the look of the website
|
| Support NGO |
|
| |
|
|
|
|
|
|
| DWHlabs Site Analytics |
| Visitors |
: |
2000 / month |
| Hits |
: |
60,000 / month |
| Advertisers |
|
Click Here |
|
|
| |
|
|
|
Data Warehousing Wallpapers |
|
|
| |
| LATEST INFORMATICA MAPPINGS |
|
1
|
Design a mapping
| Source Definition |
Target Definition |
Name
|
Sal |
| Raj |
200 |
| Ram |
300 |
| Rak |
300 |
| Lok |
400 |
| Tag |
300 |
| Brav |
500 |
| Sat |
600 |
| Nag |
500 |
|
O_RANK
|
NAME |
SAL |
| 1 |
Raj |
200 |
| 2 |
Ram |
300 |
| 2 |
Rak |
300 |
| 2 |
Tag |
300 |
| 4 |
Lok |
400 |
| 5 |
Brav |
500 |
| 5 |
Nag |
500 |
| 7 |
Sat |
600 |
|
without using Rank Transformation
|
|
2
|
Design a mapping
| Source Definition |
Target Definition |
ID
|
Name |
| 1 |
100 |
| 2 |
Ramesh |
| 3 |
INDIA |
| 1 |
101 |
| 2 |
Rakesh |
| 3 |
INDIA |
| 1 |
102 |
| 2 |
Johny |
| 3 |
USA |
|
EID
|
ENAME |
COUNTRY |
| 100 |
Ramesh |
INDIA |
| 101 |
Rakesh |
INDIA |
| 102 |
Johny |
USA |
|
|
|
3
|
Design a mapping to generate a sequence of numbers without using sequence generator by using variable functions?
|
|
4
|
Design a mapping to move first half of the data to one target and second half of the data to other target? eg., if you 20 records in source - first 10 to one target and other 10 to second target or if your source records have odd number first n/2 +1 in one target and other in second target?
|
|
5 |
I have 4 million records in my source as a flat file . i want to load the records to target. Target has four table . In the mapping , first record should go to firat table , second record will go to second table, 3rd record goes to 3rd table, 4th record goes to 4th table , Again 5th record goes to first table and then Continue the same process . How can u do this ? |
|
|
|
| WIZARD ROOTS |
1 |
Informatica Flat File Wizard - 8 steps to follow.
|
Screen Shots |
2 |
Informatica simple mapping wizard implementaion - 8 steps to follow. |
Screen Shots |
| |
|
|
| DWHLabs Latest Updates |
1 |
DIfference between Data Warehouse and Data Mining
|
Click Here |
2 |
Data Warehouse frequently asked questions guide |
|
Click Here |
|
Informatica interview questions and answers |
|
Click Here |
| |
|
|
|
|
| |
|
|
