Saturday, September 28, 2013

informatica course

›
 informatica online course
Wednesday, August 31, 2011

Informatica Real Time Scenerios

›
                   Split the non-key columns to separate tables with key column in both Scenario 2: Split the non-key columns to separate t...
1 comment:
Thursday, July 21, 2011

FTP ing the Files

›
#!/bin/sh sftp USERNAME@LOCATION_OF_FILES lcd FILES_DIRECTORY #it is the directory where your files received cd desired_directory # i...
Monday, July 18, 2011

Simple senario with solution

›
I have the source table is   Number 1 1 2 3 3 4 Target_unique                   Target_Duplicates     2                               ...
Wednesday, July 13, 2011

What is slowly changing Dimension?

›
Slowly changing dimension are dimension data, these dimensions increasing dimensions data with update ...
Thursday, June 30, 2011

If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique records in one target like 2,4 and i want load duplicate records like 1,1,3,3

›
For Unique and Duplicate , we can go for same flow :   Source-->SrcQualifier-->Aggregator(group by this column and find count also)--...

I have a scenario like - how can i load 1st record to Trgt1,2nd-Trgt2, 3rd->Trgt3 and again the cycle has to repeat with loading 4th-Trgt1,5th->Trgt2,6th->Trgt3?

›
Take a sequence generator with Start Value=1,Current Value=1,End Value=3, Increment By=1   to assign a seqno to each row. Do not forget to ...
1 comment: