rakesh


{ City } hyderabad
< Country > india
* Profession * etl developer
User No # 62145
Total Questions Posted # 12
Total Answers Posted # 22

Total Answers Posted for My Questions # 34
Total Views for My Questions # 96877

Users Marked my Answers as Correct # 94
Users Marked my Answers as Wrong # 25
Questions / { rakesh }
Questions Answers Category Views Company eMail

how we can add header and footer to flat files?

Tech Mahindra, Zensar,

2 Informatica 13956

how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!

TCS,

3 Informatica 6260

my source is a comma delimited flatfile as eno, ename, sal 111,sri,ram,kumar,1000 and my target should be eno ename sal 111 sri ram kumar 1000 i.e; we need to eliminate the commas in between the data of a comma delimited file.

IBM,

5 Informatica 7934

have you developed documents in your project? and what documents we develop in realtime?

IBM,

2 Informatica 5629

to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggregator. But here we are increasing one more cache in our mapping i.e; sorter. So how can u convince that you are increasing the performance.?

IBM,

3 Informatica 7220

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

Zensar,

2 Informatica 5749

Can anyone please distinguish what is Inner join and Outer join

Wipro,

2 Informatica 5227

What is the exact difference b/w IN and EXIST in Oracle..?

Wipro,

4 Informatica 7772

My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000

Wipro,

3 Informatica 5822

Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?

TCS,

3 Informatica 9080

What are the disadvantages of Sequence Generator T/R?

Zensar,

3 Informatica 15012

Does Facttable Normalized or Denormalized?

IBM,

2 Informatica 7216



Answers / { rakesh }

Question { 11083 }

On a day, I load 10 rows in my target and on next day if I
get 10 more rows to be added to my target out of which 5 are
updated rows how can I send them to target? How can I insert
and update the record?


Answer

Here the requirement is to update the existing record and insert the new record. Its nothing but SCD1

Is This Answer Correct ?    1 Yes 1 No

Question { IBM, 16011 }

how can we use sorter transformation in joins?


Answer

while using the option sorted input, we must have to use sorter t/r before joiner to send the sorted data to the joiner.

Is This Answer Correct ?    6 Yes 0 No


Question { ITC Infotech, 15908 }

Can we use unconnected lookup as dynamic lookup?


Answer

thanks suresh, and can any one explain why(the reason)?

Is This Answer Correct ?    2 Yes 0 No

Question { 3715 }

How can we integrate different flat file data in a single
mapping and with in a single execution


Answer

Using FileList concept.
i.e; keep all flat file paths in a text file and mention
this file name in source file name of session. and mention
the source file type as INDIRECT.

Is This Answer Correct ?    11 Yes 0 No

Question { Polaris, 8411 }

following scenario i have 1000 record flatfile source i
want ist row to ist target 2nd eow to 2nd target 3rd row to
3rd target how will u do?


Answer

use a Sequence Generator to generate a column NUM
in Router 1st Group: MOD(NUM,3)=1
2nd Group: MOD(NUM,3)=2
3rd Group: MOD(NUM,3)=0

Im not sure about MOD format, but this idea will workout..

Is This Answer Correct ?    6 Yes 3 No

Question { 6522 }

Hello all,
In SOA architecture i.e 8.6 , What is mean by node exactly?


Answer

Node is a physical entity under Domain which is a logical
entity. Just like a team member(physical) in a team(logical).
We can create number of nodes under a domain, One MASTER
NODE and number of CHILD NODES.
In Master Node we create Repository service.

Is This Answer Correct ?    1 Yes 0 No

Question { IBM, 6623 }

why union is active transformation?


Answer

since Union Transformation is derived from CUSTOM Transformation which is active.

Is This Answer Correct ?    6 Yes 0 No

Question { 4681 }

HOW TO YOU LOAD TIME DIMENSION


Answer

using stored procedure

Is This Answer Correct ?    6 Yes 1 No

Question { IBM, 5629 }

have you developed documents in your project? and what documents we develop in realtime?


Answer

Thanks Koti.
and does every developer need to develop LLD.

Is This Answer Correct ?    0 Yes 0 No

Question { TCS, 22035 }

why union transformation is active transformation?


Answer

Since union is derived from Custom T/R which is of type Active.

Is This Answer Correct ?    5 Yes 4 No

Question { CTS, 33936 }

1)how to generate sequnce numbers in informatica without
using sequnce genarator transformation.

2)i have number of records in my sourse, but iwant to
display first and last record only. how it is possible in
informatica.

3)i want to update the records without using updatestrategy
transformation.

4)what is diffrance between ab-intio and datastage than
compared to informatica.

5)what is the latest version of informatica in our field.


Answer

We can generate using MAPPING VARIABLE with SETCOUNTVARIABLE() function

Is This Answer Correct ?    15 Yes 1 No

Question { Emphasis, 7971 }

i have n number of records in my source, i want first and
last record to my target. how can u implement this scenario .


Answer

use 2 rank transformations, 1st one with top1 and 2nd one with bottom1 and connect them to 2 instances of target..

Is This Answer Correct ?    3 Yes 8 No

Question { Emphasis, 7971 }

i have n number of records in my source, i want first and
last record to my target. how can u implement this scenario .


Answer

Hi Chandrasekar,

My intension was to specify the column that is generated using sequence generator as RANK PORT. So no matter of sorting..

Thanks.

Is This Answer Correct ?    4 Yes 1 No

Question { Wipro, 5822 }

My flat file source is
C_Id 1-nov-2011 8-nov-2011
100 2000 1500
101 2500 2000
I want my Target as
C_Id Week_Num Amt
100 45 2000
100 46 1500
101 45 2500
101 46 2000


Answer

Thanks Vijaya.
In Expression we can use the date function to find the week number of the year. But here we have 1-nov-2011 as the column name, but not the column value. i.e; we have dates as column names, not as col values..
So please clarify..

Is This Answer Correct ?    2 Yes 0 No

Question { Zensar, 7055 }

can session assigned multiple mappings or not?


Answer

Session represents only one mapping. It makes the mapping available to the workflow for execution.

Is This Answer Correct ?    9 Yes 1 No

 [1]   2    Next