top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

come_dist() scenario implementation in informatica

+1 vote
193 views

Hi All ,

This is Bharat . Can somebody help me here to implement cume_dist() over(order by sal desc) in informatica with out using source qualifier .I need it immediately .

Warm Regards,
Bharat

posted Feb 18, 2016 by anonymous

Looking for an answer?  Promote on:
Facebook Share Button Twitter Share Button LinkedIn Share Button

Similar Questions
+2 votes

I need your help. I have to work on two scenarios -

There is a informatica workflow WF1 which we need to invoke at 8PM. This worflow will look for a file (ETL.txt) and if this file will not come in another 1hour (9PM), then it will get fail and send mail to support person.If file come on time, then it will run.

In a mapping the source flat file's field separator is comma (,) and if tomorrow this field separator get change to pipe (|), then how we can accomodate the change in worfkow. Is it a way that dynamically we can identity the flat file field separator?

Thanks in advance.

0 votes

I have one source table as :

S1       S2       S3       S4
 Hi      There    SSN1     SSN2 

where S1, S2, S3 and S4 are column names.

There is a target table likewise which has three fields:
T1 T2 T3

I have another table which is as follows:

Function            Target_Column
 concat(S1,S2)          T1
 substr(S3,1,3)         T2
 substr(S3,3,1)         T3 

I want to have such a mapping in which it can fetch the function name and map according to the function present in the table to the target column specified. My target table now after running the mapping will be:

T1         T2       T3
 HiThere   SSN       1

How can I achieve this?

0 votes

My source data is :

ID TimingID Timingtype
1 100 supplier
1 102 dealer
1 103 dealer
2 200 xyz
2 205 abc

I want my target to be like this :
ID T1_TimingID T1_Timingtype T2_TimingID T2_Timingtype T3_TimingID T23_Timingtype
1 100 supplier 102 dealer 103 dealer
2 200 xyz 205 abc null null

Kindly suggest.

Regards
Sandeep Nanda

...