Answer / mike

I think yes
for an unchached lookup table for every input roe the
lookup will query the lookup table to get the required rows.

HOpe this helps correct me if i was wrong

Answer / saif

uncheck the caching option.
it will hit the database for each source record.
it will give good performance in case of incremental load
(which normally process less number of rec) but for full
load it may not.

Answer / akash

By default caching is not done by informatica, if we want
to use a cache in look up we must set the same in
properties..

Please correct me if I am wrong.

Answer / shrawan

I think we can use unconnected lookup.
Correct me If i am wrong.

Answer / ravikanth

using MD5 function we can achive this.

Answer / sbvp

my ans is wrong sorry
ans: yes why because they are two types of look up t/r are
there unconn/conn acutally .in that cache/uncahe look t/r's ok

Answer / sbvp

No,informatica server creates default index cache and data
cache. to evry transformations

Whether Aggrigator transformation ignore the null values or consider the null values ? Advance Thanks, Manojkumar

3 Answers   IBM,

i have source data like id name sal 1 a 65020 2 b 78250 3 c 58264 but how to get target like this id name sal 1 a Sixty five thousand twenty 2 b Seventy thousand two fify 3 c Fifty eight thousand two sixty four

3 Answers  

how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)

2 Answers   Sonata,

Diffrence between 7.1,8.1 and 8.6

3 Answers   HCL, Wipro,

how to move the mappings from your local machine to claint place?

2 Answers  

Whatis the difference between View and Materialized View ?

11 Answers   Satyam, Syntel,

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

0 Answers  

You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 - writer buffer block can hold multiple 7,500 rows - you are loading 40,000 records into the target After how many records will the Informatica Server issue commit commands? a)7500, 15000, 22500, 30000, 40000 b)15000, 22500, 30000, 37500, 40000 c)15000, 22500, 30000, 40000 d)15000, 30000, 40000

7 Answers   Deloitte,

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

0 Answers   Infotech,

can anyone explain me about sales project in informatica?

8 Answers   MBT, Satyam,

what type of transformation is not supported by mapplets?

4 Answers   CTS,

What are active transformations? Name them.

1 Answers