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

Shashikumar

• Jun 21st, 2007

Data Cleansing Tool: TriliumProfile tool: Informatica Profiler

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

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

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

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

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

N SRIRAM K

 Profile Answers by N SRIRAM K Questions by N SRIRAM K

• Jun 5th, 2007

The default user groups:      1) Administrators      2) Public

Answer Question  Select Best Answer

Navin

• Jun 2nd, 2007

With 32-bit the max memory?you can have for a session is 2^32With 64-bit?the max memory you can have 2^64 - more memory means?faster execution of sessionNavin

Answer Question  Select Best Answer

imran.nabi

 Profile Answers by imran.nabi Questions by imran.nabi

• May 30th, 2007

Hi,You can do it through file list. You have create a file containing path of all file. And u have to give that file name in session properties and select indirect.Thanks,imran

Answer Question  Select Best Answer

imran.nabi

 Profile Answers by imran.nabi Questions by imran.nabi

• May 29th, 2007

Hi Manish Bhai, Cofiguration management means when u r installing the informatica that time u have some options to set according to ur choice. Like u want to use unicode and ascii mode, there r some other options. I have only this much idea about it. If i am right then tell me.ThanksImran Nabi

Answer Question  Select Best Answer

imran.nabi

 Profile Answers by imran.nabi Questions by imran.nabi

• May 29th, 2007

Hi,The new Version Informatica 8.1 has got some additional feature's like:1) Mapping Generation Option2) Push Down Optimisation3) Data Cleanse and Match4) Data Federation (EII)5) Enterprise Grid6)...

Answer Question  Select Best Answer

ex-: Suppose a table EMP is in MAINFRAME then how can we access this table as SOURCE TABLE in informatica?

latha

• May 29th, 2007

Use the Normalizer transformation to take the Mainframe sources(COBOL)

vishnukirank

 Profile Answers by vishnukirank Questions by vishnukirank

• May 26th, 2007

Use Informatica Power Connect to connect to external systems like Mainframes and import the source tables.

Answer Question  Select Best Answer

Which transformation you can use to get n+1 records in Target database from N records source

imran.nabi

 Profile Answers by imran.nabi Questions by imran.nabi

• May 29th, 2007

Normalizer bcoz it increases the no of rows. I hope it will help u.Thanks,imran

Answer Question  Select Best Answer

Abhishek Pathak

• May 25th, 2007

Main difference between using a object from shared folder is that it will be used as Shortcut to shared folder so in future if any changes happened to that object so by changing its definition in...

Answer Question  Select Best Answer

naga

• May 24th, 2007

In realtime star schema is the better one. Surrogate key is linked to the lowest level. For example?country, state, city, area in this surrogate key is with 'AREA'

shaik

• Jun 27th, 2006

In real time only star schema will implement because it will take less time and surrogate key will there in each and every dimension table in star schema and this surrogate key will assign as foreign key in fact table.

Answer Question  Select Best Answer