Interested to Buy Any Domain ? << Click Here >> for more details...
What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.
1 7140Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
HP,
5 11393write a query to get maximum salary from the employers table without duplicates....kindly help me
CTS,
5 10043Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is the output for this query???....plz answer
TCS,
3 7250hi talents, how do u get sequece numbers with oracle sequence generator function in informatica.... i dont need to use sequence generator transformation..... how do u achieve this???
HP,
3 9058What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort
1 5887Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformations? Why? Can anybody please explain it ? Please help me out from this Question. Thanks In Advance.
CTS,
2 13977HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.
CTS,
8 14934i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load should be ID NAME SAL 101 A 1000 101 B 2000 101 C 1500 102 A 1000 102 B 2000 102 C 1500 103 A 1000 103 B 2000 103 C 1500
TCS,
3 6436By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?
5 9134If u r giving different parameter file names in workflow and session for a single mapping parameter, then which one will be executed? The one u given in workflow or the one u given in the session?
1 6662Post New Informatica Questions
What are the main issues while working with flat files as source and as targets ?
difference between repository database and repository service?
tell me about your project functionality
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Which means the first record should come as last record and last record should come as first record and load into the target file?
How an expression transformation differs from aggregator transformation?
Mention few power centre client applications with their basic purpose?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
During the running session, output files are created by informatica server. Enlist few of them.
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What is informatica metadata and where is it stored?
Explain how many types of dimensions are available in informatica?
EXL informatica Questions
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
