mehul


{ City } pune
< Country > india
* Profession * etl consultant
User No # 68812
Total Questions Posted # 43
Total Answers Posted # 6

Total Answers Posted for My Questions # 96
Total Views for My Questions # 321755

Users Marked my Answers as Correct # 3
Users Marked my Answers as Wrong # 3
Questions / { mehul }
Questions Answers Category Views Company eMail

How informatica process data means how informatica works?

TCS,

2 Informatica 12298

Can we run session without using workflows?

TCS,

5 Informatica 20655

What is the internal processes of integration server in Informatica? How data will be extract and load to the target?

TCS,

Informatica 2475

Is LOAD MANAGER AND LOAD BALANCER same in informatica?

KPIT,

1 Informatica 9179

If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?

TCS,

1 Informatica 6721

Which is better performance wise database or file?How?

TCS,

2 Informatica 5724

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

 2 Informatica 5450

I i have 2 tables A & B ,A contains 10 records B contains 20 records ,what w'll be the o/p if we perform equijoin,outer join,right outer join,left outer join,full outer join,cross join seperately Can anyone help on this?

 2 SQL PLSQL 6468

Can anyone guide me the steps to install informatica PC 8.5.1 with database as oracle

 1 Informatica 3465

how to join two flat files in informatica?

Wipro,

3 Informatica 17898

how to join two flat file if they have diff. structure?how to join one relational and one flat file?

Wipro,

4 Informatica 8161

if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.

Wipro,

5 Informatica 8223

in what type of scenario bulk loading and normal loading we use?

Cognizant, Wipro,

2 Informatica 5933

how can we run workflow with pmcmd?

Wipro,

3 Informatica 7705

why we use informatica in our project?

TCS,

2 Informatica 6705

 [1]   2   3    Next



Answers / { mehul }

Question { 9553 }

wt is inline view? when and why we Use ?mail to
rayallarv@gmail.com


Answer

The concept of using subquery in the FROM clause of SELECT statement is called INLINE VIEW.
A subquery in the from clause of SELECT statement defines a data source from that particular statement.

Is This Answer Correct ?    2 Yes 0 No

Question { 6407 }

i have one table like
cust_id ph1 ph2 ph3
1002 9290123526 97671927210 9876545232
we use Normalizer wt is o/p?
sue normalizer we can generate three tables in single table/


Answer

In normalizer tab of normalizer tr. set no of occurence to 3
since we have 3 phno,which in turn create 3 i/p port in port tab,u hav to create exp tr. betn normalizer and target and map GCID_phno to expression tr. say out_phno and give condition in expression like decode(GCID_phno,1002,9290123526,1002,97671927210,1002,9876545232);
It might help u

Is This Answer Correct ?    1 Yes 0 No


Question { 3574 }

Dovelopment work (mapings,workflows)and unit testing also
done in informatica ,then wt we do ?
pls give me detail?


Answer

We scheduled our workflow using contol-M or Autosys etc.Then we migrated our code to diff environment like QA,Staging,Production,If any issue they found they revert the code back to us and we fix that issues again and sent back to them,then we prepare migration docs .

Is This Answer Correct ?    0 Yes 1 No

Question { Wipro, 17898 }

how to join two flat files in informatica?


Answer

Hi Rajesh
could you plz tell me the steps to join from joiner tr.

Regards
Mehul Thakur

Is This Answer Correct ?    0 Yes 1 No

Question { Wipro, 8161 }

how to join two flat file if they have diff. structure?how to join one relational and one flat file?


Answer

Hi sravanti
Could U please explain how to join ?

Is This Answer Correct ?    0 Yes 1 No

Question { Emphasis, 7072 }

,if we have single SQ in flow and we have router in which it
has two group and we want to join these two groups with
joiner ?is it possible?


Answer

Hi Sree

Could u please elaborate your solution

Is This Answer Correct ?    0 Yes 0 No