How to kill 10 workflows at a a time ?

vizaik

 Profile Answers by vizaik Questions by vizaik

• Oct 25th, 2011

Write 10 pmcmd commands with abortworkflow option in one bat/sh file and execute at once

wanilkumar

 Profile Answers by wanilkumar Questions by wanilkumar

• Oct 7th, 2011

It is not possible to kill multiple workflows at a time. You must Abort/Stop one at a time.

I think starting with the version 8.6 you can run the same workflow multiple times at the same time.

Answer Question  Select Best Answer

vizaik

 Profile Answers by vizaik Questions by vizaik

• Oct 25th, 2011

Excel source is possible through File DSN - Target XML also can be done - read the documentation or help for more information

kumar

• Oct 21st, 2011

First we need to save the excel file in csv file and then we have xml transformation in informatica by using that we can convert csv file to xml file

Answer Question  Select Best Answer

What are the different types of partitons in Informatica?

• Oct 21st, 2011

Informatica partitions are used to improve the performance of power center through parallel data processing. The different types of informatica partitions are database partition, pass-through partitio...

Answer Question  Select Best Answer

In session level, What is the difference between Informatica 7 and 8

sridkaretl

 Profile Answers by sridkaretl Questions by sridkaretl

• Oct 21st, 2011

The main difference is

1) Architecture difference
2) Java trasformation has been introduced
3)user defined functions
4)dynamic configuration of cache and partitioning.

Answer Question  Select Best Answer

What is the significance of the file odbc.ini?

sridkaretl

 Profile Answers by sridkaretl Questions by sridkaretl

• Oct 21st, 2011

The main significance of ODBC is it to connect to the desired database and fetch the data.

Sriteja

• Aug 27th, 2011

One of the uses of the ODBC.ini file is to handle SQL Server, Teradata connections from Unix flavoured Informatica Server installations...

There can be more to it.. However, we use odbc.ini in our project to connect SQL Server database from powercenter installed in Linux server..

Answer Question  Select Best Answer

Explain how the batch processing works in informatica ? When would it be useful in real-time projects ?

snigdha ojha

• Oct 12th, 2011

When we run multiple sessions in a single workflow sequentially that is called batch processing. This is useful when we create relational database for any company.

Answer Question  Select Best Answer

What is bridge table?

surendra

• Oct 11th, 2011

When we need to do many to many relation ship between dimensional table and fact table we can it as Bridge Table , simply we can bridge table sits between fact table and dimensional Table ..

Answer Question  Select Best Answer

The goal of performance tuning is optimize session performance so sessions run during the available load window for the Informatica Server.Increase the session performance by following. The performance of the Informatica Server is related to network connections. Data generally moves across a network at less than 1 MB per second, whereas a local disk moves data five to twenty times faster. Thus network...

srinivas

• Oct 4th, 2011

Your approach to that question and answer is perfect and correct

ankitmohansharma

 Profile Answers by ankitmohansharma Questions by ankitmohansharma

• Jan 13th, 2008

Hey, Thank You so much for the information. That was one of the best answers I have read on this website. Descriptive yet to the point and highly useful in real world. I appreciate your effort.

Answer Question  Select Best Answer

hima

• Sep 26th, 2011

Detailed filter is used before an aggregator transformation .

Summarised filter? One used after the aggregator transformation

Amiyangshu Pal

• Aug 17th, 2006

Will it be correct to say that Summary Filter ----> HAVING Clause in SQLDetails Filter ------> WHERE Clause in SQL

Answer Question  Select Best Answer

Hemachandra

• Sep 26th, 2011

With my knowledge BY using LIST FILE we can do

jayapraveen

 Profile Answers by jayapraveen Questions by jayapraveen

• Oct 8th, 2010

with my knowledge Consider the 500 file as a flat file and import it considering it as a flat file by fixed length or fixed tab, delimiters OR we can do in this way also by exporting the 500 file as xml file and import in source analyzer by using import from xml file

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

Rajsuni  

 Profile Answers by Rajsuni Questions by Rajsuni

• Member Since Apr-2011 | Apr 1st, 2011

---

 Informatica Architecture :
            
   client tools-
                  Repositoy Manager->  Pc Designer->    WFManager->           WFMonitor       
                            |                               |                          |                                |
              (creat,mdify,del-folders,    (src&Tar def,         (create tasks             (display
              privilages& access RS)     mapings,maPlets)connect to work flow) reult/output)
   ---------------------

   Powercenter tools--
                   PC service   <--------------------->Repository Database
                          |
                          |
         <-------> PC Server<---->

here: Pc-PowerCenter.

venkat m

• Sep 20th, 2011

Informatica Architecture : client tools- Repositoy Manager-> Pc Designer-> WFManager-> WFMonitor | ...

ram_infa

 Profile Answers by ram_infa Questions by ram_infa

• Sep 15th, 2011

When we install the informatica powercenter, the following components gets ionstalled 1) powercenter clients 2) Integration service 3) powercenter Repository service 4) powercenter Repository 5) power...

Improve Answer

The data movement mode depends on whether Informatica Server should process single byte or multi-byte character data. This mode selection can affect the enforcement of code page relationships and code page validation in the Informatica Client and Server.a) Unicode - IS allows 2 bytes for each character and uses additional byte for each non-ascii character (such as Japanese characters)b) ASCII - IS...

Read Best Answer

Editorial / Best Answer

Answered by: purushotham

• Aug 9th, 2005

---

the two types of modes are: 
1) Normal Mode in which for every record a separate DML stmt will be prepared and executed 
 
Bulk Mode in which for multiple records DML stmt will be preapred and executed thus improves performance.

amolrenose

 Profile Answers by amolrenose Questions by amolrenose

• Sep 18th, 2011

Data Movement Modes

1. ASCII mode :- Single byte of data is processed.
2. UNICODE mode :- Two bytes of data is processed.

Data Loading Modes

1. Normal Mode :- Commit is executed after 10000 records (default).
2. Bulk Mode :- Commit is executed after all records have been loaded.

sivakp

 Profile Answers by sivakp Questions by sivakp

• Mar 13th, 2011

1. ASCII mode2. UNICODE mode

Improve Answer

Read Best Answer

Editorial / Best Answer

gazulas  

 Profile Answers by gazulas Questions by gazulas

• Member Since Jan-2006 | Jan 29th, 2006

---

if supported by the database  bulk load can do the loading faster than normal load.(incremental load concept is differnt dont merge with bulk load, mormal load)

ram_infa

 Profile Answers by ram_infa Questions by ram_infa

• Sep 14th, 2011

It's totally depends upon the requirement. generally bulk load is faster caz it won't write the data to database logs so we can't do session recovery where as in normal load it is very slow comparing to bulk but the advantage is we can do session recovery..

vikota

 Profile Answers by vikota Questions by vikota

• Apr 12th, 2011

 Incremental load: Incremental means suppose today  we processed 100 records ,for tomorrow  run u need to extract  whatever the records inserted newly and  updated after ...

Improve Answer

ram_infa

 Profile Answers by ram_infa Questions by ram_infa

• Sep 14th, 2011

If both the tables are relational we can join both the tables using sql override but if one table is relational and another table is a flat then we've to use joiner transformation.

vikota

 Profile Answers by vikota Questions by vikota

• Apr 12th, 2011

If both the tables are available in same database by using source qualifier we can join i.e by using customized source qualifierif the tables are available in different database by using lookup we can join i.e one is source table and other is lookup table

Answer Question  Select Best Answer

srinivas

• Sep 14th, 2011

In Informatica 8.6, recovery feature is improved. Informatica server writes real time recovery info to a queue which helps maintain data integrity during recovery. So, no data is lost or duplicated. R...

uppala chary

• Aug 28th, 2011

In session properties use session recovery strategy.

Answer Question  Select Best Answer

ram_infa

 Profile Answers by ram_infa Questions by ram_infa

• Sep 13th, 2011

Nope! when you use bulk loading you can't recover the rows caz it won't write database logs.

suresh.ravirala

• Mar 17th, 2006

no,why because in bulk load u wont create redo log file,when u normal load we create redo log file,but in bulk load session performance increases

Answer Question  Select Best Answer

ram_infa

 Profile Answers by ram_infa Questions by ram_infa

• Sep 13th, 2011

Look up transformation helps us to look for a data in a flat file,relational,view synonym. Lookup transformation can be used to get a related value and in a slowly changing dimensions Update strategy...

Kathir

• Oct 6th, 2006

In Lookup transformation the source table look to the other tables what the destination you needBut in update stratergy you required empty field you have to fill it

Answer Question  Select Best Answer

Persistent cache: U can save the lookup cache files and reuse them the next time the informatica server processes a lookup transformation configured to use the cache. Recache from database: If the persistent cache is not synchronized with he lookup table,U can configure the lookup transformation to rebuild the lookup cache. Static cache: U can configure a static or readonly cache for only lookup table.By...

adhoc

• Sep 13th, 2011

There are 2 important caches. 1. Static : By default integration service chooses statyic cache.It is read only cache . when you first query the lookup table, it caches the table. whenever a row com...

Mattock

• Sep 7th, 2011

Caches are of following types:
1. Static Cache
2. Dynamic Cache
3. Persistent Cache
4. Non-persistent Cache
5. Shared Cache
6. Un-shared Cache

More types to follow...:-)

Answer Question  Select Best Answer

Informatica server manager.

ram_infa

 Profile Answers by ram_infa Questions by ram_infa

• Sep 12th, 2011

Workflow manager is used to create,manage sessions and batches

Workflow Monitor is used to monitor, abort/stop the sessions

KarthikeyanVCSS

 Profile Answers by KarthikeyanVCSS Questions by KarthikeyanVCSS

• Jun 30th, 2011

Informatica Server Manager - Tool that we are using to create and manage Sessions and Batches.

Answer Question  Select Best Answer

Any number of sessions.

ram_infa

 Profile Answers by ram_infa Questions by ram_infa

• Sep 12th, 2011

No limit

Syed Muzaffer Uddin

 Profile Answers by Syed Muzaffer Uddin Questions by Syed Muzaffer Uddin

• Jun 22nd, 2011

Any number of session can be created in the batch, but the best practice is to have less number of tasks, it will help at the time of migration.

Answer Question  Select Best Answer