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 # 310203

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 12078

Can we run session without using workflows?

TCS,

5 Informatica 20083

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

TCS,

Informatica 2378

Is LOAD MANAGER AND LOAD BALANCER same in informatica?

KPIT,

1 Informatica 9015

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 6547

Which is better performance wise database or file?How?

TCS,

2 Informatica 5507

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

 2 Informatica 5231

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 6152

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

 1 Informatica 3271

how to join two flat files in informatica?

Wipro,

3 Informatica 17380

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

Wipro,

4 Informatica 7820

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 7738

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

Cognizant, Wipro,

2 Informatica 5686

how can we run workflow with pmcmd?

Wipro,

3 Informatica 7351

why we use informatica in our project?

TCS,

2 Informatica 6483

 [1]   2   3    Next



Answers / { mehul }

Question { 9295 }

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 { 6050 }

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 { 3359 }

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, 17380 }

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, 7820 }

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, 6805 }

,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