- 6
- 6 955
Utsav
เข้าร่วมเมื่อ 19 มิ.ย. 2022
Technology, Tutorials, Reviews and Lifestyle
วีดีโอ
SQL 101: Joins Explained: Part 1
มุมมอง 1422 ปีที่แล้ว
How Joins Work. Why are they needed. All these questions are answered in this video.
How to load a hierarchical XML file via Informatica
มุมมอง 2.1K2 ปีที่แล้ว
How to load a hierarchical XML file via Informatica
How to Load a simple XML source file via Informatica
มุมมอง 6682 ปีที่แล้ว
How to Load a simple XML source file via Informatica
How to load Unstructured Flat File via Informatica PowerCenter
มุมมอง 8362 ปีที่แล้ว
How to load Unstructured Flat File via Informatica PowerCenter
How to find Employee with max(salary) in each department via Informatica PowerCenter
มุมมอง 2.8K2 ปีที่แล้ว
In this tutorial, we would see that how can we find maximum salary of each department via Informatica PowerCenter. Sample HR schema employee table is used as source.
I have a scenario I want to load top 3rd salary record using informatica
if, I need the 2nd highest salary by department wise mean..how to achieve that.
Hi Utsav, how does the XSD file get the data from XML file? Since it contains only metadata information, how is it linked to XML file to get actual data
Hi Watch Raj informatica channel, there is a solution for that
I have a mapping where joiner is not used , how do we know that fk and pk are populated based on which column?
Super sir
Sir We can write the above query in source qualifier query option
Of course you can. The point of the video is to achieve this via Informatica. Imagine if the source is a flat file, then you have to use Informatica transformations to achieve it.
Sir how we load unstructured data to load to the error table with having lacks of records please explain to me Sir.
Can you give your sample source data and expected output.
This is good info Utsav, thanks for sharing this, I have couple of questions and a request 1. Will this functionality work in any version of the Informatica? 2. Does it always have to be xsd file? Can xml file be imported as source? 3. Request, If possible, can you have one same video where we take data from xml and insert into SFDC?
Well explained!! Thanks.. Wish you had attached the source.
Great explanation. Even a non SQL person like me understood the concept. I like the SQL editor, which one is it?
Thanks. SQL Editor is DBeaver.
Nice
Very Nice Video. Keep it up. Your 1st subscriber 😍