rsannu2k

 Profile Answers by rsannu2k Questions by rsannu2k

• Jun 7th, 2007

two ways.1. go to navigation panel, under the mapping expand the Transformations folder, will list all the transformation including lookups... 2. but if you want to lookup and browse through only look...

SRIRAM N

• May 17th, 2007

You can have look on all the look-ups that are avialable in a mapping through,???????????? Workflow--> session --> EDIT (and look in MAPPINGS tab)

Answer Question  Select Best Answer

rsannu2k

 Profile Answers by rsannu2k Questions by rsannu2k

• Jun 7th, 2007

Rangini,Incremental Aggregations, I think informatica provides this feature to load the sessions which are abruptly termination in middle of the load, am I right? also I would like to know how you can...

Rangini vignesh

• Aug 30th, 2006

The above answer is slightly correct.The incremental loading is done in 3 ways by using Transformations.1.Aggregate Transformation,2.Dynamic Lookup Transformation,3.Update Strategy Transformation,In t...

Answer Question  Select Best Answer

Prasad P

• Jun 11th, 2007

You can join that table which you wanted to use in lookup in the source qualifier using SQL override to avoid using lookup transformation

muzamil

• Aug 2nd, 2006

 You can use joiner in place of lookup

Answer Question  Select Best Answer

Pradeep Behera

• Jun 20th, 2007

Materialized view stores the result set of?a query, but normal view does not store the same. We can refresh the Materialised View when any changes are made in the master table. Normal view is only ...

rma

• Dec 12th, 2006

View doesn't occupy any storage space in table space, but meterilized view will occupy space

Answer Question  Select Best Answer

yuva010

• Jun 20th, 2007

There is no as such best way, but you have to incorporate following steps -1. Change the name in Mapping Designer2. Refresh mapping?with right click on?session3. Reset the target connections.4. Save.

Answer Question  Select Best Answer

Shashikumar

• Jun 21st, 2007

Data Cleansing Tool: TriliumProfile tool: Informatica Profiler

Answer Question  Select Best Answer

It can be possible by using %a in Session Components POST SESSION EMAIL tab.

madhavkash

• Jun 22nd, 2007

Register the flat file as source and create a mapping with file as source.After SQ Txf, create a Filter Txf and make it false to write to a dummy target.Create a workflow and in that session variable SrcSuccessRows > 0 True means you have data False means no data

Answer Question  Select Best Answer

When I use the Informatica Workflow Monitor, I can see the properties by double clicking the running session task. But where is the file about the properties, because I want to read the information of the properties through some other development tools. I checked the log file, the it is not what I want. So anyone can help me to get the contents of the properties? Thank you very much~~

N SRIRAM K

 Profile Answers by N SRIRAM K Questions by N SRIRAM K

• Jun 25th, 2007

The properties will be stored in a table of Repository data base.Please check the tables.For any further queries: sriram_kumar@oneindia.in

Answer Question  Select Best Answer

Vaishali

• Jun 25th, 2007

Decode can be used in select statement whereas IIF cannot be used.

raj

• Dec 27th, 2005

U can use decode in conditioning coloumns also while we cann't use iff but u can use case. but by using decode retrieveing data is quick  

Answer Question  Select Best Answer

A Router transformation is similar to a Filter transformation because both transformations allow you to use a condition to test data. However, a Filter transformation tests data for one condition and drops the rows of data that do not meet the condition. A Router transformation tests data for one or more conditions and gives you the option to route rows of data that do not meet any of the conditions...

Rksinghpathania

 Profile Answers by Rksinghpathania Questions by Rksinghpathania

• Jun 27th, 2007

Note:- i think the definition and purpose of Router transformation define by sithusithu, sithu is not clear and not fully correct as they of have mentioned <A Router transformation tests data for o...

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 19th, 2006

A Router transformation is similar to a Filter transformation because both transformations allow you to use a condition to test data. A Filter transformation tests data for one condition and drops the...

Answer Question  Select Best Answer

mohammed haneef

• Jun 28th, 2007

Hi,Joiner Cache will use in Joiner t/r  to improve the performance. While using joiner cache informatica server first read the data from master source and built data index & data cache in the...

Answer Question  Select Best Answer

madarapu

 Profile Answers by madarapu Questions by madarapu

• Jul 3rd, 2007

Yes we can if the soure and target is from same type of database then we can use a same odbc(dsn) for both of them.

Answer Question  Select Best Answer

Adil M

• Jul 4th, 2007

De-normalization is basically the concept of keeping all the dimension hierarchies in a single dimensions tables. This causes less number of joins while retriving data from dimensions and hence faster data retrival. This is why dimensions in OLAP systems are de-normalized.

Stephen Ross

• Mar 29th, 2007

I am a beginner to DW, but as I know fact tables - DenormalizedAnd Dimension Tables - Normalized.If I am wrong, please correct.

Answer Question  Select Best Answer

Adil M

• Jul 10th, 2007

This is because we cannot use a Non Reusable Sequence Generator Transformation in a mapplet. Hence we must use a Re usable Sequence Generator. The fact that we reuse mapplets has no bearing over why we should use a reusable SG.

madarapu

 Profile Answers by madarapu Questions by madarapu

• Jul 3rd, 2007

Since mapplet is to reusability so if we include  a sequence generator inside a mapplet.the mapplet which we r going to reuse it for next time the sequence generator properties would be changed.so that we can not recommend it inside a mapplet which gives inproper result set.

Answer Question  Select Best Answer

babu

• Jul 11th, 2007

In?above the condition satisfies is:1 satisfies A , A or B2?satisfies?B,?A or B1, 2?does not satisfies it goes to DEFAULTThere is no use of?A and B.

Answer Question  Select Best Answer